﻿<%@ Page Title="Home Page" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
    CodeBehind="list.aspx.vb" Inherits="prototype._Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <p>
        &nbsp;</p>
    <p>
        <a href="../RSSfeed.aspx"><img alt="" style="width: 30px ; height:30px; border: none;" src="../Pictures/rss.png" /></a>
        </p>
<p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="ClubDataSource" CellPadding="4" ForeColor="#333333" 
        GridLines="None" AllowSorting="True" Width="100%">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:HyperLinkField DataNavigateUrlFields="ID" 
                DataNavigateUrlFormatString="details.aspx?ID={0}" DataTextField="FirstName" 
                HeaderText="FirstName" SortExpression="FirstName" />
            <asp:BoundField DataField="LastName" HeaderText="LastName" 
                SortExpression="LastName" />
            <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
            <asp:BoundField DataField="PlayingPosition" HeaderText="PlayingPosition" 
                SortExpression="PlayingPosition" />
            <asp:BoundField DataField="ClubGoals" HeaderText="ClubGoals" 
                SortExpression="ClubGoals" />
            <asp:BoundField DataField="InternationalGoals" HeaderText="InternationalGoals" 
                SortExpression="InternationalGoals" />
            <asp:ImageField DataImageUrlField="PlayerPicture" HeaderText="Tumbnail">
                <ControlStyle cssclass="thumbnail" />
            </asp:ImageField>
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>
    <asp:SqlDataSource ID="ClubDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:PlayersConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:PlayersConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT [FirstName], [LastName], [Age], [PlayingPosition], [ClubGoals], [InternationalGoals], [PlayerPicture], [ID] FROM [Players]">
    </asp:SqlDataSource>
    </p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    <br />
</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
</p>
</asp:Content>
